Project Overview

CV-19 Grantmaking strategic planning analytics (Phase 1)

An atlas of COVID-19 era need and philanthropic response in the Delaware Valley Region


July 2020


Where have Delaware Valley philanthropies allocated emergency COVID-19 resources, and how do those resources align with need? For this project, a series of strategic planning analytics have been designed to help stakeholders target future grantmaking where it is most in need.

Visit County Reports above to investigate the geography of grantmaking and need regionally and by county. Visit the About page for more information on this ongoing project.


County grantmaking and need statistics


The below table provides a county-by-county comparison of COVID-19 outcomes, grantmaking and the need for resources.



Strategic planning overlay map


The goal of the map below is to help stakeholders target future grantmaking. Darker shades of blue show Census tracts where there is more relative need, here defined by a Social Vulnerability index, than relative grantmaking. Stakeholders may wish to invest more in these places. Shades of white indicate alignment between relative need and grantmaking. Darker shades of red are places where grantmaking is in relative excess. Perform this analysis on your area of interest using the Strategic Planning Tool (need link)



This work was supported by a coalition philanthropic organizations in the Delaware Valley Region and created by the below entities.

County Reports

County Level Analysis

About

About this project


The goal of the CV19 Regional Strategic Planning dashboard is to help coordinate across-organization, placed-based investment in communities hardest hit by COVID-19. The dashboard includes data on 2292 grants from ten philanthropic funds operating in the Delaware Valley Region.


TUse the Strategic Planning Tool to see where grantmaking aligns with the need for resources. Use the County Reports to view a wealth of relevant analytics about individual counties in the region.


How to use the site?

  • How can I compare COVID-19 outcomes, grantmaking, and overall need for resources across counties?’ Use the table on the Project Overview page to compare summary statistics across county.

  • ‘How can I learn more about granting and need for each individual county in the region?’ Use the County Reports page to view detailed maps and indicators for each county in the region.

  • ‘How can my organization use these data to plan future investments?’ Use the Strategic Planning Tool (need link) to visualize need and granting by Census tract and use the overlay functionality to see on a relative basis, where need is not being met.


The future of this effort

This is one of the first efforts we are aware of to collect and standardize geospatial grantmaking information across multiple philanthropies. The future of this tool can help philanthropies:

  1. Promote across-organization strategic planning by analyzing grants made by multiple organizations in a single community.
  2. Manage placed-based grants by understanding the social, economic, and health-related context within and without supported communities.
  3. Promote placed-based evaluation by comparing outcomes for supported communities to outcomes in comparable areas.


In this project, the emphasis was to quickly build an analytical engine and visualization platform to respond to the crisis. We anticipate future versions to be more visually engaging and perhaps even be compatible with existing Customer Relationship Management (CRM) software used in the Philanthropic sector.


Data Sources


Theme Source Year Link
Housing American Community Survey (ACS), Homeland Infrastructure Foundation-Level Data (HIFLD) 2014-2018, 2019 https://data.census.gov/cedsci/, https://gii.dhs.gov/hifld/content/hifld-data-catalog
Demographics ACS, HIFLD 2014-2018, 2019 https://data.census.gov/cedsci/, https://gii.dhs.gov/hifld/content/hifld-data-catalog
Employment LODES/LEHD, BLS Unemployment 2015, 2020 https://lehd.ces.census.gov/data/, https://www.bls.gov/cew/
Food Insecurity ACS, USDA Food Atlas 2014-2018, 2015 https://data.census.gov/cedsci/, https://www.ers.usda.gov/data-products/food-access-research-atlas/download-the-data/
Child Welfare ACS, HIFLD 2014-2018, 2019 https://data.census.gov/cedsci/, https://gii.dhs.gov/hifld/content/hifld-data-catalog
Health ACS, HIFLD 2014-2018, 2019 https://data.census.gov/cedsci/, https://gii.dhs.gov/hifld/content/hifld-data-catalog